Before beginning, we must first make a few temporary minor adjustments to our spreadsheet.

Copying A Data Range

Click cell A2
Highlight the
data range A2 through F2


    You can do this by dragging your mouse "plus" cursor from A2 through F2.

Click the Copy button which on the standard toolbar.

    Excel puts a moving marquee around the highlighted cells and copies them to the clipboard.

Click cell A6
Click the Paste button
Press Enter


    Excel copies the highlighted cells from the clipboard the new cell location, starting at cell A6.

Now your turn! Try it!